Also see common JDBC Translator Information

The DB2 Translator, known by the type name db2, if for use with DB2 8 or later and DB2 for i 5.4 or later.

DB2 specific execution properties:

• DB2ForI- indicates that the the DB2 instance is DB2 for i. Defaults to false.

• supportsCommonTableExpressions- indicates that the DB2 instance supports Common Table Expressions. Defaults to true. Some older versions, or instances running in a conversion mode, of DB2 lack full common table expression support and may need support disabled.